SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwePlazasConsolidadas
AS
SELECT    P.IdPlaza AS ID, P.Baja, P.FechaBaja, P.NormaCierre, 
                      P.Observaciones
FROM         dbo.tb_Plazas P 
GO
GRANT SELECT ON  [dbo].[vwePlazasConsolidadas] TO [Direcciones De Nivel]
GRANT INSERT ON  [dbo].[vwePlazasConsolidadas] TO [Direcciones De Nivel]
GRANT DELETE ON  [dbo].[vwePlazasConsolidadas] TO [Direcciones De Nivel]
GRANT UPDATE ON  [dbo].[vwePlazasConsolidadas] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vwePlazasConsolidadas] TO [MCEEjecutivo]
GRANT SELECT ON  [dbo].[vwePlazasConsolidadas] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwePlazasConsolidadas] TO [PersonalDocenteDireccion]
GRANT UPDATE ON  [dbo].[vwePlazasConsolidadas] TO [PersonalDocenteDireccion]
GO
